FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Chart Namespace > SpreadChart Class > GenerateFromCellRanges Method : GenerateFromCellRanges(SheetView,CellRange[],Boolean) Method |
true
, the processing switches rows and columns automatically, if necessary.
'Declaration Public Overloads Sub GenerateFromCellRanges( _ ByVal sheetView As SheetView, _ ByVal cellRanges() As CellRange, _ ByVal autoSwitch As Boolean _ )
'Usage Dim instance As SpreadChart Dim sheetView As SheetView Dim cellRanges() As CellRange Dim autoSwitch As Boolean instance.GenerateFromCellRanges(sheetView, cellRanges, autoSwitch)
public void GenerateFromCellRanges( SheetView sheetView, CellRange[] cellRanges, bool autoSwitch )
true
, the processing switches rows and columns automatically, if necessary.FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart(typeof(FarPoint.Web.Chart.BarSeries)); chart.GenerateFromCellRanges(FpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), new FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), new FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), true); FpSpread1.Sheets[0].Charts.Add(chart);
Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart(GetType(FarPoint.Web.Chart.BarSeries)) chart.GenerateFromCellRanges(FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(1, 0, 6, 1), New FarPoint.Web.Spread.Model.CellRange(0, 1, 1, 3), New FarPoint.Web.Spread.Model.CellRange(1, 1, 6, 3), True) FpSpread1.Sheets(0).Charts.Add(chart)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6